AddRange(NamedStyle[]) Method

Visual Basic
C#

'Declaration
 
Public Overloads Overridable Sub AddRange( _
   ByVal array() As NamedStyle _
)

'Usage
 
Dim instance As NamedStyleCollection
Dim array() As NamedStyle
 
instance.AddRange(array)

public virtual void AddRange( 
   NamedStyle[] array
)

Parameters

array: Array of NamedStyle objects to add to the collection

This method adds an array of NamedStyle objects to the collection.

This example adds a range of styles to the collection.

C#

FarPoint.Web.Spread.NamedStyleCollection nsc = new FarPoint.Web.Spread.NamedStyleCollection();
FarPoint.Web.Spread.NamedStyle ns = new FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault");
FarPoint.Web.Spread.NamedStyle ns1 = new FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault");
System.Collections.ArrayList c = new System.Collections.ArrayList(2);
ns.BackColor = Color.Yellow;
ns.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue);
ns1.BackColor = Color.Teal;
ns1.Border = new FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red);
c.Add(ns);
c.Add(ns1);
nsc.AddRange(c);
FpSpread1.NamedStyles.AddRange(new Object[] {nsc[0], nsc[1]});
FpSpread1.ActiveSheetView.DefaultStyle = nsc[0];
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc[1];

Visual Basic

Dim nsc As New FarPoint.Web.Spread.NamedStyleCollection
Dim ns As New FarPoint.Web.Spread.NamedStyle("StyleData", "DataAreaDefault")
Dim ns1 As New FarPoint.Web.Spread.NamedStyle("HeaderData", "HeaderDefault")
Dim c As New System.Collections.ArrayList(2)
ns.BackColor = Color.Yellow
ns.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Blue)
ns1.BackColor = Color.Teal
ns1.Border = New FarPoint.Web.Spread.Border(BorderStyle.Double, Color.Red)
c.Add(ns)
c.Add(ns1)
nsc.AddRange(c)
FpSpread1.NamedStyles.AddRange(New Object() {nsc(0), nsc(1)})
FpSpread1.ActiveSheetView.DefaultStyle = nsc(0)
FpSpread1.ActiveSheetView.ColumnHeader.DefaultStyle = nsc(1)

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

NamedStyleCollection Class
NamedStyleCollection Members
Overload List